Olist customer

Dataset statistics

Number of variables	37
Number of observations	118434
Missing cells	26666
Missing cells (%)	0.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	38.4 MiB
Average record size in memory	339.7 B

Variable types

Text	8
Numeric	18
Categorical	5
DateTime	6

Alerts

`customer_state` is highly overall correlated with `customer_zip_code_prefix`	High correlation
`customer_zip_code_prefix` is highly overall correlated with `customer_state`	High correlation
`payment_value` is highly overall correlated with `price`	High correlation
`price` is highly overall correlated with `payment_value` and 1 other fields	High correlation
`product_height_cm` is highly overall correlated with `product_weight_g`	High correlation
`product_length_cm` is highly overall correlated with `product_weight_g` and 1 other fields	High correlation
`product_weight_g` is highly overall correlated with `price` and 3 other fields	High correlation
`product_width_cm` is highly overall correlated with `product_length_cm` and 1 other fields	High correlation
`seller_state` is highly overall correlated with `seller_zip_code_prefix`	High correlation
`seller_zip_code_prefix` is highly overall correlated with `seller_state`	High correlation
`order_status` is highly imbalanced (91.6%)	Imbalance
`payment_type` is highly imbalanced (52.6%)	Imbalance
`seller_state` is highly imbalanced (63.2%)	Imbalance
`order_delivered_carrier_date` has 2074 (1.8%) missing values	Missing
`order_delivered_customer_date` has 3397 (2.9%) missing values	Missing
`product_name_lenght` has 2528 (2.1%) missing values	Missing
`product_description_lenght` has 2528 (2.1%) missing values	Missing
`product_photos_qty` has 2528 (2.1%) missing values	Missing
`product_category` has 2553 (2.2%) missing values	Missing
`order_purchase_hour` has 2910 (2.5%) zeros	Zeros

Reproduction

Analysis started	2024-08-05 15:33:56.166358
Analysis finished	2024-08-05 15:35:41.853676
Duration	1 minute and 45.69 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

customer_id
Text

Distinct	99441
Distinct (%)	84.0%
Missing	0
Missing (%)	0.0%
Memory size	5.8 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3789888
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	86952 ?
Unique (%)	73.4%

Sample

1st row	06b8999e2fba1a1fbc88172c00ba8bc7
2nd row	18955e83d337fd6b2def6b18a428ac77
3rd row	4e7b3e00288586ebd08712fdd0374a03
4th row	b2b6027bc5c5109e529d4dc6358b12c3
5th row	4f2d8ab171c80ec8364f7c12e35b23ad

Value	Count	Frequency (%)
270c23a11d024a44c896d1894b261a83	63	0.1%
13aa59158da63ba0e93ec6ac2c07aacb	38	< 0.1%
9af2372a1e49340278e7c1ef8d749f34	29	< 0.1%
92cd3ec6e2d643d4ebd0e3d6238f69e2	26	< 0.1%
6ee2f17e3b6c33d6a9557f280edd2925	24	< 0.1%
d22f25a9fadfb1abbc2e29395b1239f4	24	< 0.1%
63b964e79dee32a3587651701a2b8dbf	24	< 0.1%
86cc80fef09f7f39df4b0dbce48e81cb	24	< 0.1%
b246eeed30b362c09d867b9e598bee51	22	< 0.1%
5e0f7317756669ff7b384444dbb81fa3	21	< 0.1%
Other values (99431)	118139	99.8%

Most occurring characters

Value	Count	Frequency (%)
f	237574	6.3%
2	237529	6.3%
5	237365	6.3%
c	237224	6.3%
6	237112	6.3%
1	237092	6.3%
8	236965	6.3%
d	236915	6.3%
a	236874	6.3%
7	236840	6.2%
Other values (6)	1418398	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2367827	62.5%
Lowercase Letter	1422061	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	237529	10.0%
5	237365	10.0%
6	237112	10.0%
1	237092	10.0%
8	236965	10.0%
7	236840	10.0%
3	236818	10.0%
9	236542	10.0%
4	235900	10.0%
0	235664	10.0%

Lowercase Letter

Value	Count	Frequency (%)
f	237574	16.7%
c	237224	16.7%
d	236915	16.7%
a	236874	16.7%
b	236757	16.6%
e	236717	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2367827	62.5%
Latin	1422061	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	237529	10.0%
5	237365	10.0%
6	237112	10.0%
1	237092	10.0%
8	236965	10.0%
7	236840	10.0%
3	236818	10.0%
9	236542	10.0%
4	235900	10.0%
0	235664	10.0%

Latin

Value	Count	Frequency (%)
f	237574	16.7%
c	237224	16.7%
d	236915	16.7%
a	236874	16.7%
b	236757	16.6%
e	236717	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3789888	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
f	237574	6.3%
2	237529	6.3%
5	237365	6.3%
c	237224	6.3%
6	237112	6.3%
1	237092	6.3%
8	236965	6.3%
d	236915	6.3%
a	236874	6.3%
7	236840	6.2%
Other values (6)	1418398	37.4%

customer_unique_id
Text

Distinct	96096
Distinct (%)	81.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3789888
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	81671 ?
Unique (%)	69.0%

Sample

1st row	861eff4711a542e4b93843c6dd7febb0
2nd row	290c77bc529b7ac935b93aa66c333dc3
3rd row	060e732b5b29e8181a18229c7b0b2b5e
4th row	259dac757896d24d7702b9acbbff3f3c
5th row	345ecd01c38d18a9036ed96c73b8d066

Value	Count	Frequency (%)
9a736b248f67d166d2fbb006bcb877c3	75	0.1%
6fbc7cdadbb522125f4b27ae9dee4060	38	< 0.1%
f9ae226291893fda10af7965268fb7f6	35	< 0.1%
8af7ac63b2efbcbd88e5b11505e8098a	29	< 0.1%
569aa12b73b5f7edeaa6f2a01603e381	26	< 0.1%
db1af3fd6b23ac3873ef02619d548f9c	24	< 0.1%
85963fd37bfd387aa6d915d8a1065486	24	< 0.1%
5419a7c9b86a43d8140e2939cd2c2f7e	24	< 0.1%
c8460e4251689ba205045f3ea17884a1	24	< 0.1%
2524dcec233c3766f2c2b22f69fd65f4	22	< 0.1%
Other values (96086)	118113	99.7%

Most occurring characters

Value	Count	Frequency (%)
6	237846	6.3%
b	237438	6.3%
1	237367	6.3%
a	237304	6.3%
d	237140	6.3%
3	237130	6.3%
8	237023	6.3%
2	236840	6.2%
5	236810	6.2%
e	236743	6.2%
Other values (6)	1418247	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2368540	62.5%
Lowercase Letter	1421348	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	237846	10.0%
1	237367	10.0%
3	237130	10.0%
8	237023	10.0%
2	236840	10.0%
5	236810	10.0%
9	236734	10.0%
0	236475	10.0%
7	236468	10.0%
4	235847	10.0%

Lowercase Letter

Value	Count	Frequency (%)
b	237438	16.7%
a	237304	16.7%
d	237140	16.7%
e	236743	16.7%
f	236629	16.6%
c	236094	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2368540	62.5%
Latin	1421348	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
6	237846	10.0%
1	237367	10.0%
3	237130	10.0%
8	237023	10.0%
2	236840	10.0%
5	236810	10.0%
9	236734	10.0%
0	236475	10.0%
7	236468	10.0%
4	235847	10.0%

Latin

Value	Count	Frequency (%)
b	237438	16.7%
a	237304	16.7%
d	237140	16.7%
e	236743	16.7%
f	236629	16.6%
c	236094	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3789888	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	237846	6.3%
b	237438	6.3%
1	237367	6.3%
a	237304	6.3%
d	237140	6.3%
3	237130	6.3%
8	237023	6.3%
2	236840	6.2%
5	236810	6.2%
e	236743	6.2%
Other values (6)	1418247	37.4%

customer_zip_code_prefix
Real number (ℝ)

HIGH CORRELATION

Distinct	14994
Distinct (%)	12.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35034.264

Minimum	1003
Maximum	99990
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	1003
5-th percentile	3275
Q1	11310
median	24240
Q3	58464.5
95-th percentile	90560
Maximum	99990
Range	98987
Interquartile range (IQR)	47154.5

Descriptive statistics

Standard deviation	29819.29
Coefficient of variation (CV)	0.85114646
Kurtosis	-0.78080429
Mean	35034.264
Median Absolute Deviation (MAD)	16230
Skewness	0.78547825
Sum	4.1492481 × 10⁹
Variance	8.8919007 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24220	161	0.1%
22790	155	0.1%
22793	154	0.1%
24230	138	0.1%
22775	129	0.1%
35162	124	0.1%
29101	119	0.1%
11740	111	0.1%
13087	106	0.1%
38400	106	0.1%
Other values (14984)	117131	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1003	1	< 0.1%
1004	2	< 0.1%
1005	6	< 0.1%
1006	2	< 0.1%
1007	4	< 0.1%
1008	4	< 0.1%
1009	8	< 0.1%
1011	6	< 0.1%
1012	3	< 0.1%
1013	3	< 0.1%

Value	Count	Frequency (%)
99990	1	< 0.1%
99980	3	< 0.1%
99970	1	< 0.1%
99965	2	< 0.1%
99960	2	< 0.1%
99955	3	< 0.1%
99950	9	< 0.1%
99940	2	< 0.1%
99930	5	< 0.1%
99925	1	< 0.1%

customer_city
Text

Distinct	4119
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Memory size	5.8 MiB

Length

Max length	32
Median length	27
Mean length	10.335622
Min length	3

Characters and Unicode

Total characters	1224089
Distinct characters	31
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1037 ?
Unique (%)	0.9%

Sample

1st row	franca
2nd row	sao bernardo do campo
3rd row	sao paulo
4th row	mogi das cruzes
5th row	campinas

Value	Count	Frequency (%)
sao	25280	12.2%
paulo	18820	9.1%
de	11576	5.6%
rio	9902	4.8%
janeiro	8252	4.0%
do	5072	2.4%
belo	3346	1.6%
horizonte	3300	1.6%
brasilia	2483	1.2%
porto	1984	1.0%
Other values (3285)	117718	56.7%

Most occurring characters

Value	Count	Frequency (%)
a	201908	16.5%
o	151033	12.3%
i	93579	7.6%
r	90680	7.4%
	89299	7.3%
e	79475	6.5%
s	75013	6.1%
n	54237	4.4%
u	53750	4.4%
l	53333	4.4%
Other values (21)	281782	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1134240	92.7%
Space Separator	89299	7.3%
Dash Punctuation	286	< 0.1%
Other Punctuation	262	< 0.1%
Decimal Number	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	201908	17.8%
o	151033	13.3%
i	93579	8.3%
r	90680	8.0%
e	79475	7.0%
s	75013	6.6%
n	54237	4.8%
u	53750	4.7%
l	53333	4.7%
p	44505	3.9%
Other values (16)	236727	20.9%

Decimal Number

Value	Count	Frequency (%)
1	1	50.0%
4	1	50.0%

Space Separator

Value	Count	Frequency (%)
	89299	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	286	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	262	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1134240	92.7%
Common	89849	7.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	201908	17.8%
o	151033	13.3%
i	93579	8.3%
r	90680	8.0%
e	79475	7.0%
s	75013	6.6%
n	54237	4.8%
u	53750	4.7%
l	53333	4.7%
p	44505	3.9%
Other values (16)	236727	20.9%

Common

Value	Count	Frequency (%)
	89299	99.4%
-	286	0.3%
'	262	0.3%
1	1	< 0.1%
4	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1224089	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	201908	16.5%
o	151033	12.3%
i	93579	7.6%
r	90680	7.4%
	89299	7.3%
e	79475	6.5%
s	75013	6.1%
n	54237	4.4%
u	53750	4.4%
l	53333	4.4%
Other values (21)	281782	23.0%

customer_state
Categorical

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 MiB

SP	49967
RJ	15420
MG	13738
RS	6521
PR	6017
Other values (22)	26771

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	236868
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SP
2nd row	SP
3rd row	SP
4th row	SP
5th row	SP

Common Values

Value	Count	Frequency (%)
SP	49967	42.2%
RJ	15420	13.0%
MG	13738	11.6%
RS	6521	5.5%
PR	6017	5.1%
SC	4328	3.7%
BA	4071	3.4%
DF	2489	2.1%
GO	2443	2.1%
ES	2347	2.0%
Other values (17)	11093	9.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	49967	42.2%
rj	15420	13.0%
mg	13738	11.6%
rs	6521	5.5%
pr	6017	5.1%
sc	4328	3.7%
ba	4071	3.4%
df	2489	2.1%
go	2443	2.1%
es	2347	2.0%
Other values (17)	11093	9.4%

Most occurring characters

Value	Count	Frequency (%)
S	64415	27.2%
P	60302	25.5%
R	28926	12.2%
M	16739	7.1%
G	16181	6.8%
J	15420	6.5%
A	6855	2.9%
E	6204	2.6%
C	5983	2.5%
B	4714	2.0%
Other values (7)	11129	4.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	236868	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	64415	27.2%
P	60302	25.5%
R	28926	12.2%
M	16739	7.1%
G	16181	6.8%
J	15420	6.5%
A	6855	2.9%
E	6204	2.6%
C	5983	2.5%
B	4714	2.0%
Other values (7)	11129	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	236868	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	64415	27.2%
P	60302	25.5%
R	28926	12.2%
M	16739	7.1%
G	16181	6.8%
J	15420	6.5%
A	6855	2.9%
E	6204	2.6%
C	5983	2.5%
B	4714	2.0%
Other values (7)	11129	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	236868	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	64415	27.2%
P	60302	25.5%
R	28926	12.2%
M	16739	7.1%
G	16181	6.8%
J	15420	6.5%
A	6855	2.9%
E	6204	2.6%
C	5983	2.5%
B	4714	2.0%
Other values (7)	11129	4.7%

order_id
Text

Distinct	99441
Distinct (%)	84.0%
Missing	0
Missing (%)	0.0%
Memory size	5.8 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3789888
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	86952 ?
Unique (%)	73.4%

Sample

1st row	00e7ee1b050b8499577073aeb2a297a1
2nd row	29150127e6685892b6eab3eec79f59c7
3rd row	b2059ed67ce144a36e2aa97d2c9e9ad2
4th row	951670f92359f4fe4a63112aa7306eba
5th row	6b7d50bd145f6fc7f33cebabd7e49d0f

Value	Count	Frequency (%)
895ab968e7bb0d5659d16cd74cd1650c	63	0.1%
fedcd9f7ccdc8cba3a18defedd1a5547	38	< 0.1%
fa65dad1b0e818e3ccc5cb0e39231352	29	< 0.1%
ccf804e764ed5650cd8759557269dc13	26	< 0.1%
c6492b842ac190db807c15aff21a7dd6	24	< 0.1%
a3725dfe487d359b5be08cac48b64ec5	24	< 0.1%
465c2e1bee4561cb39e0db8c5993aafc	24	< 0.1%
68986e4324f6a21481df4e6e89abcf01	24	< 0.1%
285c2e15bebd4ac83635ccc563dc71f4	22	< 0.1%
958c6a70e60365b576dd696ad29bbca2	21	< 0.1%
Other values (99431)	118139	99.8%

Most occurring characters

Value	Count	Frequency (%)
4	237976	6.3%
b	237895	6.3%
6	237797	6.3%
e	237449	6.3%
3	237239	6.3%
8	237121	6.3%
c	237072	6.3%
7	237053	6.3%
1	237035	6.3%
a	236741	6.2%
Other values (6)	1416510	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2368219	62.5%
Lowercase Letter	1421669	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	237976	10.0%
6	237797	10.0%
3	237239	10.0%
8	237121	10.0%
7	237053	10.0%
1	237035	10.0%
2	236488	10.0%
9	236349	10.0%
0	235705	10.0%
5	235456	9.9%

Lowercase Letter

Value	Count	Frequency (%)
b	237895	16.7%
e	237449	16.7%
c	237072	16.7%
a	236741	16.7%
f	236462	16.6%
d	236050	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2368219	62.5%
Latin	1421669	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
4	237976	10.0%
6	237797	10.0%
3	237239	10.0%
8	237121	10.0%
7	237053	10.0%
1	237035	10.0%
2	236488	10.0%
9	236349	10.0%
0	235705	10.0%
5	235456	9.9%

Latin

Value	Count	Frequency (%)
b	237895	16.7%
e	237449	16.7%
c	237072	16.7%
a	236741	16.7%
f	236462	16.6%
d	236050	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3789888	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	237976	6.3%
b	237895	6.3%
6	237797	6.3%
e	237449	6.3%
3	237239	6.3%
8	237121	6.3%
c	237072	6.3%
7	237053	6.3%
1	237035	6.3%
a	236741	6.2%
Other values (6)	1416510	37.4%

order_status
Categorical

IMBALANCE

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 MiB

delivered	115038
shipped	1245
canceled	745
unavailable	650
processing	375
Other values (3)	381

Length

Max length	11
Median length	9
Mean length	8.9835689
Min length	7

Characters and Unicode

Total characters	1063960
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	delivered
2nd row	delivered
3rd row	delivered
4th row	delivered
5th row	delivered

Common Values

Value	Count	Frequency (%)
delivered	115038	97.1%
shipped	1245	1.1%
canceled	745	0.6%
unavailable	650	0.5%
processing	375	0.3%
invoiced	373	0.3%
created	5	< 0.1%
approved	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
delivered	115038	97.1%
shipped	1245	1.1%
canceled	745	0.6%
unavailable	650	0.5%
processing	375	0.3%
invoiced	373	0.3%
created	5	< 0.1%
approved	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	349260	32.8%
d	232447	21.8%
i	118054	11.1%
l	117083	11.0%
v	116064	10.9%
r	115421	10.8%
p	2871	0.3%
a	2703	0.3%
c	2243	0.2%
n	2143	0.2%
Other values (7)	5671	0.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1063960	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	349260	32.8%
d	232447	21.8%
i	118054	11.1%
l	117083	11.0%
v	116064	10.9%
r	115421	10.8%
p	2871	0.3%
a	2703	0.3%
c	2243	0.2%
n	2143	0.2%
Other values (7)	5671	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1063960	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	349260	32.8%
d	232447	21.8%
i	118054	11.1%
l	117083	11.0%
v	116064	10.9%
r	115421	10.8%
p	2871	0.3%
a	2703	0.3%
c	2243	0.2%
n	2143	0.2%
Other values (7)	5671	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1063960	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	349260	32.8%
d	232447	21.8%
i	118054	11.1%
l	117083	11.0%
v	116064	10.9%
r	115421	10.8%
p	2871	0.3%
a	2703	0.3%
c	2243	0.2%
n	2143	0.2%
Other values (7)	5671	0.5%

order_purchase_timestamp
Date

Distinct	98875
Distinct (%)	83.5%
Missing	0
Missing (%)	0.0%
Memory size	5.8 MiB

Minimum	2016-09-04 21:15:19
Maximum	2018-10-17 17:30:18

Histogram

Histogram with fixed size bins (bins=50)

order_approved_at
Date

Distinct	90733
Distinct (%)	76.7%
Missing	176
Missing (%)	0.1%
Memory size	5.8 MiB

Minimum	2016-09-15 12:16:38
Maximum	2018-09-03 17:40:06

Histogram

Histogram with fixed size bins (bins=50)

order_delivered_carrier_date
Date

MISSING

Distinct	81018
Distinct (%)	69.6%
Missing	2074
Missing (%)	1.8%
Memory size	5.8 MiB

Minimum	2016-10-08 10:34:01
Maximum	2018-09-11 19:48:28

Histogram

Histogram with fixed size bins (bins=50)

order_delivered_customer_date
Date

MISSING

Distinct	95664
Distinct (%)	83.2%
Missing	3397
Missing (%)	2.9%
Memory size	5.8 MiB

Minimum	2016-10-11 13:46:32
Maximum	2018-10-17 13:22:46

Histogram

Histogram with fixed size bins (bins=50)

order_estimated_delivery_date
Date

Distinct	459
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	5.8 MiB

Minimum	2016-09-30 00:00:00
Maximum	2018-11-12 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

order_item_id
Real number (ℝ)

Distinct	21
Distinct (%)	< 0.1%
Missing	830
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	1.1959202

Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	21
Range	20
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.69772067
Coefficient of variation (CV)	0.58341741
Kurtosis	104.20293
Mean	1.1959202
Median Absolute Deviation (MAD)	0
Skewness	7.5710461
Sum	140645
Variance	0.48681413
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	103057	87.0%
2	10239	8.6%
3	2376	2.0%
4	986	0.8%
5	469	0.4%
6	262	0.2%
7	60	0.1%
8	36	< 0.1%
9	28	< 0.1%
10	25	< 0.1%
Other values (11)	66	0.1%
(Missing)	830	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	103057	87.0%
2	10239	8.6%
3	2376	2.0%
4	986	0.8%
5	469	0.4%
6	262	0.2%
7	60	0.1%
8	36	< 0.1%
9	28	< 0.1%
10	25	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	3	< 0.1%
19	3	< 0.1%
18	3	< 0.1%
17	3	< 0.1%
16	3	< 0.1%
15	5	< 0.1%
14	7	< 0.1%
13	8	< 0.1%
12	13	< 0.1%

product_id
Text

Distinct	32951
Distinct (%)	28.0%
Missing	830
Missing (%)	0.7%
Memory size	5.8 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3763328
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17444 ?
Unique (%)	14.8%

Sample

1st row	a9516a079e37a9c9c36b9b78b10169e8
2nd row	4aa6014eceb682077f9dc4bffebc05b0
3rd row	bd07b66896d6f1494f5b86251848ced7
4th row	a5647c44af977b148e0a3a4751a09e2e
5th row	9391a573abe00141c56e38d84d7d5b3b

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	536	0.5%
99a4788cb24856965c36a24e339b6058	525	0.4%
422879e10f46682990de24d770e7f83d	505	0.4%
389d119b48cf3043d311335e499d9c6b	406	0.3%
368c6c730842d78016ad823897a372db	395	0.3%
53759a2ecddad2bb87a079a1f1519f73	389	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	357	0.3%
53b36df67ebb7c41585e8d54d6772e08	327	0.3%
154e7e31ebfa092203795c972e5804a6	283	0.2%
3dd2a17168ec895c781a9191c1e95ad7	278	0.2%
Other values (32941)	113603	96.6%

Most occurring characters

Value	Count	Frequency (%)
3	241732	6.4%
9	239628	6.4%
e	237452	6.3%
8	236819	6.3%
7	236771	6.3%
4	236040	6.3%
a	235924	6.3%
c	234931	6.2%
0	234839	6.2%
2	234705	6.2%
Other values (6)	1394487	37.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2361683	62.8%
Lowercase Letter	1401645	37.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	241732	10.2%
9	239628	10.1%
8	236819	10.0%
7	236771	10.0%
4	236040	10.0%
0	234839	9.9%
2	234705	9.9%
6	234263	9.9%
5	234216	9.9%
1	232670	9.9%

Lowercase Letter

Value	Count	Frequency (%)
e	237452	16.9%
a	235924	16.8%
c	234931	16.8%
b	233596	16.7%
d	231370	16.5%
f	228372	16.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	2361683	62.8%
Latin	1401645	37.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	241732	10.2%
9	239628	10.1%
8	236819	10.0%
7	236771	10.0%
4	236040	10.0%
0	234839	9.9%
2	234705	9.9%
6	234263	9.9%
5	234216	9.9%
1	232670	9.9%

Latin

Value	Count	Frequency (%)
e	237452	16.9%
a	235924	16.8%
c	234931	16.8%
b	233596	16.7%
d	231370	16.5%
f	228372	16.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3763328	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	241732	6.4%
9	239628	6.4%
e	237452	6.3%
8	236819	6.3%
7	236771	6.3%
4	236040	6.3%
a	235924	6.3%
c	234931	6.2%
0	234839	6.2%
2	234705	6.2%
Other values (6)	1394487	37.1%

seller_id
Text

Distinct	3095
Distinct (%)	2.6%
Missing	830
Missing (%)	0.7%
Memory size	5.8 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3763328
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	491 ?
Unique (%)	0.4%

Sample

1st row	7c67e1448b00f6e969d365cea6b010ab
2nd row	b8bc237ba3788b23da09c0f1f3a3288c
3rd row	7c67e1448b00f6e969d365cea6b010ab
4th row	7c67e1448b00f6e969d365cea6b010ab
5th row	4a3ca9315b744ce9f8e9374361493884

Value	Count	Frequency (%)
4a3ca9315b744ce9f8e9374361493884	2133	1.8%
6560211a19b47992c3666cc44a7e94c0	2122	1.8%
1f50f920176fa81dab994f9023523100	2008	1.7%
cc419e0650a3c5ba77189a1882b7556a	1847	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1639	1.4%
955fee9216a65b617aa5c0531780ce60	1528	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1462	1.2%
7c67e1448b00f6e969d365cea6b010ab	1452	1.2%
7a67c85e85bb2ce8582c35f2203ad736	1240	1.1%
ea8482cd71df3c1969d7b9473ff13abc	1239	1.1%
Other values (3085)	100934	85.8%

Most occurring characters

Value	Count	Frequency (%)
1	255271	6.8%
c	248272	6.6%
4	246945	6.6%
6	242188	6.4%
0	241220	6.4%
a	239844	6.4%
b	239238	6.4%
3	239187	6.4%
9	233721	6.2%
2	232497	6.2%
Other values (6)	1344945	35.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2380420	63.3%
Lowercase Letter	1382908	36.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	255271	10.7%
4	246945	10.4%
6	242188	10.2%
0	241220	10.1%
3	239187	10.0%
9	233721	9.8%
2	232497	9.8%
8	230272	9.7%
5	229725	9.7%
7	229394	9.6%

Lowercase Letter

Value	Count	Frequency (%)
c	248272	18.0%
a	239844	17.3%
b	239238	17.3%
e	221358	16.0%
f	217994	15.8%
d	216202	15.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2380420	63.3%
Latin	1382908	36.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	255271	10.7%
4	246945	10.4%
6	242188	10.2%
0	241220	10.1%
3	239187	10.0%
9	233721	9.8%
2	232497	9.8%
8	230272	9.7%
5	229725	9.7%
7	229394	9.6%

Latin

Value	Count	Frequency (%)
c	248272	18.0%
a	239844	17.3%
b	239238	17.3%
e	221358	16.0%
f	217994	15.8%
d	216202	15.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3763328	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	255271	6.8%
c	248272	6.6%
4	246945	6.6%
6	242188	6.4%
0	241220	6.4%
a	239844	6.4%
b	239238	6.4%
3	239187	6.4%
9	233721	6.2%
2	232497	6.2%
Other values (6)	1344945	35.7%

shipping_limit_date
Date

Distinct	93318
Distinct (%)	79.3%
Missing	830
Missing (%)	0.7%
Memory size	5.8 MiB

Minimum	2016-09-19 00:15:34
Maximum	2020-04-09 22:35:08

Histogram

Histogram with fixed size bins (bins=50)

price
Real number (ℝ)

HIGH CORRELATION

Distinct	5968
Distinct (%)	5.1%
Missing	830
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	120.82285

Minimum	0.85
Maximum	6735
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	0.85
5-th percentile	17
Q1	39.9
median	74.9
Q3	134.9
95-th percentile	349.9
Maximum	6735
Range	6734.15
Interquartile range (IQR)	95

Descriptive statistics

Standard deviation	184.47737
Coefficient of variation (CV)	1.5268417
Kurtosis	118.86346
Mean	120.82285
Median Absolute Deviation (MAD)	42
Skewness	7.8857991
Sum	14209250
Variance	34031.899
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.9	2606	2.2%
69.9	2092	1.8%
49.9	2045	1.7%
89.9	1623	1.4%
99.9	1510	1.3%
39.9	1395	1.2%
29.9	1378	1.2%
19.9	1279	1.1%
79.9	1276	1.1%
29.99	1221	1.0%
Other values (5958)	101179	85.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.85	3	< 0.1%
1.2	20	< 0.1%
2.2	2	< 0.1%
2.29	1	< 0.1%
2.9	1	< 0.1%
2.99	1	< 0.1%
3	2	< 0.1%
3.06	3	< 0.1%
3.49	3	< 0.1%
3.5	7	< 0.1%

Value	Count	Frequency (%)
6735	1	< 0.1%
6729	1	< 0.1%
6499	1	< 0.1%
4799	1	< 0.1%
4690	1	< 0.1%
4590	1	< 0.1%
4399.87	1	< 0.1%
4099.99	1	< 0.1%
4059	1	< 0.1%
3999.9	1	< 0.1%

freight_value
Real number (ℝ)

Distinct	6999
Distinct (%)	6.0%
Missing	830
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	20.045551

Minimum	0
Maximum	409.68
Zeros	390
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	0
5-th percentile	7.78
Q1	13.08
median	16.29
Q3	21.19
95-th percentile	45.3
Maximum	409.68
Range	409.68
Interquartile range (IQR)	8.11

Descriptive statistics

Standard deviation	15.861351
Coefficient of variation (CV)	0.79126539
Kurtosis	57.583093
Mean	20.045551
Median Absolute Deviation (MAD)	3.63
Skewness	5.5429427
Sum	2357437
Variance	251.58245
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.1	3831	3.2%
7.78	2339	2.0%
11.85	1972	1.7%
14.1	1971	1.7%
18.23	1625	1.4%
7.39	1568	1.3%
16.11	1194	1.0%
15.23	1061	0.9%
8.72	964	0.8%
16.79	924	0.8%
Other values (6989)	100155	84.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	390	0.3%
0.01	4	< 0.1%
0.02	3	< 0.1%
0.03	14	< 0.1%
0.04	4	< 0.1%
0.05	9	< 0.1%
0.06	13	< 0.1%
0.07	1	< 0.1%
0.08	12	< 0.1%
0.09	6	< 0.1%

Value	Count	Frequency (%)
409.68	1	< 0.1%
375.28	2	< 0.1%
339.59	1	< 0.1%
338.3	1	< 0.1%
322.1	1	< 0.1%
321.88	1	< 0.1%
321.46	1	< 0.1%
317.47	1	< 0.1%
314.4	1	< 0.1%
314.02	1	< 0.1%

payment_sequential
Real number (ℝ)

Distinct	29
Distinct (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.0942068

Minimum	1
Maximum	29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	29
Range	28
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7282895
Coefficient of variation (CV)	0.66558674
Kurtosis	346.64585
Mean	1.0942068
Median Absolute Deviation (MAD)	0
Skewness	15.881705
Sum	129588
Variance	0.5304056
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
1	113332	95.7%
2	3397	2.9%
3	651	0.5%
4	318	0.3%
5	191	0.2%
6	134	0.1%
7	92	0.1%
8	61	0.1%
9	50	< 0.1%
10	41	< 0.1%
Other values (19)	164	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	113332	95.7%
2	3397	2.9%
3	651	0.5%
4	318	0.3%
5	191	0.2%
6	134	0.1%
7	92	0.1%
8	61	0.1%
9	50	< 0.1%
10	41	< 0.1%

Value	Count	Frequency (%)
29	1	< 0.1%
28	1	< 0.1%
27	1	< 0.1%
26	2	< 0.1%
25	2	< 0.1%
24	2	< 0.1%
23	2	< 0.1%
22	3	< 0.1%
21	6	< 0.1%
20	6	< 0.1%

payment_type
Categorical

IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Memory size	5.8 MiB

credit_card	87286
boleto	23037
voucher	6407
debit_card	1698
not_defined	3

Length

Max length	11
Median length	11
Mean length	9.7966749
Min length	6

Characters and Unicode

Total characters	1160230
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	credit_card
2nd row	credit_card
3rd row	credit_card
4th row	credit_card
5th row	credit_card

Common Values

Value	Count	Frequency (%)
credit_card	87286	73.7%
boleto	23037	19.5%
voucher	6407	5.4%
debit_card	1698	1.4%
not_defined	3	< 0.1%
(Missing)	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
credit_card	87286	73.7%
boleto	23037	19.5%
voucher	6407	5.4%
debit_card	1698	1.4%
not_defined	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
c	182677	15.7%
r	182677	15.7%
d	177974	15.3%
e	118434	10.2%
t	112024	9.7%
i	88987	7.7%
_	88987	7.7%
a	88984	7.7%
o	52484	4.5%
b	24735	2.1%
Other values (6)	42267	3.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1071243	92.3%
Connector Punctuation	88987	7.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
c	182677	17.1%
r	182677	17.1%
d	177974	16.6%
e	118434	11.1%
t	112024	10.5%
i	88987	8.3%
a	88984	8.3%
o	52484	4.9%
b	24735	2.3%
l	23037	2.2%
Other values (5)	19230	1.8%

Connector Punctuation

Value	Count	Frequency (%)
_	88987	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1071243	92.3%
Common	88987	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
c	182677	17.1%
r	182677	17.1%
d	177974	16.6%
e	118434	11.1%
t	112024	10.5%
i	88987	8.3%
a	88984	8.3%
o	52484	4.9%
b	24735	2.3%
l	23037	2.2%
Other values (5)	19230	1.8%

Common

Value	Count	Frequency (%)
_	88987	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1160230	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
c	182677	15.7%
r	182677	15.7%
d	177974	15.3%
e	118434	10.2%
t	112024	9.7%
i	88987	7.7%
_	88987	7.7%
a	88984	7.7%
o	52484	4.5%
b	24735	2.1%
Other values (6)	42267	3.6%

payment_installments
Real number (ℝ)

Distinct	24
Distinct (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.9373981

Minimum	0
Maximum	24
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	10
Maximum	24
Range	24
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.7741644
Coefficient of variation (CV)	0.94442914
Kurtosis	2.5218464
Mean	2.9373981
Median Absolute Deviation (MAD)	1
Skewness	1.6227641
Sum	347879
Variance	7.6959881
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1	59117	49.9%
2	13794	11.6%
3	11814	10.0%
4	8027	6.8%
10	6899	5.8%
5	6056	5.1%
8	5077	4.3%
6	4638	3.9%
7	1839	1.6%
9	735	0.6%
Other values (14)	435	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	59117	49.9%
2	13794	11.6%
3	11814	10.0%
4	8027	6.8%
5	6056	5.1%
6	4638	3.9%
7	1839	1.6%
8	5077	4.3%
9	735	0.6%

Value	Count	Frequency (%)
24	34	< 0.1%
23	1	< 0.1%
22	1	< 0.1%
21	5	< 0.1%
20	21	< 0.1%
18	38	< 0.1%
17	8	< 0.1%
16	7	< 0.1%
15	92	0.1%
14	16	< 0.1%

payment_value
Real number (ℝ)

HIGH CORRELATION

Distinct	29077
Distinct (%)	24.6%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	172.84939

Minimum	0
Maximum	13664.08
Zeros	9
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	0
5-th percentile	27.18
Q1	60.86
median	108.2
Q3	189.245
95-th percentile	515.94
Maximum	13664.08
Range	13664.08
Interquartile range (IQR)	128.385

Descriptive statistics

Standard deviation	268.25983
Coefficient of variation (CV)	1.5519859
Kurtosis	499.70102
Mean	172.84939
Median Absolute Deviation (MAD)	56.63
Skewness	13.969151
Sum	20470727
Variance	71963.337
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	351	0.3%
100	300	0.3%
20	286	0.2%
77.57	250	0.2%
35	166	0.1%
73.34	160	0.1%
30	139	0.1%
116.94	131	0.1%
56.78	123	0.1%
65	119	0.1%
Other values (29067)	116406	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	< 0.1%
0.01	6	< 0.1%
0.03	2	< 0.1%
0.05	2	< 0.1%
0.07	1	< 0.1%
0.08	2	< 0.1%
0.09	1	< 0.1%
0.1	3	< 0.1%
0.11	2	< 0.1%
0.13	2	< 0.1%

Value	Count	Frequency (%)
13664.08	8	< 0.1%
7274.88	4	< 0.1%
6929.31	1	< 0.1%
6922.21	1	< 0.1%
6726.66	1	< 0.1%
6081.54	6	< 0.1%
4950.34	1	< 0.1%
4809.44	2	< 0.1%
4764.34	1	< 0.1%
4681.78	1	< 0.1%

product_name_lenght
Real number (ℝ)

MISSING

Distinct	66
Distinct (%)	0.1%
Missing	2528
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%
Mean	48.767208

Minimum	5
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	5
5-th percentile	29
Q1	42
median	52
Q3	57
95-th percentile	60
Maximum	76
Range	71
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.035162
Coefficient of variation (CV)	0.20577685
Kurtosis	0.15160625
Mean	48.767208
Median Absolute Deviation (MAD)	6
Skewness	-0.90552833
Sum	5652412
Variance	100.70448
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59	8630	7.3%
60	8030	6.8%
56	6797	5.7%
58	6776	5.7%
57	6271	5.3%
55	5797	4.9%
54	5489	4.6%
53	4338	3.7%
52	4296	3.6%
49	3665	3.1%
Other values (56)	55817	47.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	9	< 0.1%
6	3	< 0.1%
7	2	< 0.1%
8	4	< 0.1%
9	15	< 0.1%
10	9	< 0.1%
11	11	< 0.1%
12	38	< 0.1%
13	26	< 0.1%
14	47	< 0.1%

Value	Count	Frequency (%)
76	1	< 0.1%
72	9	< 0.1%
69	1	< 0.1%
68	1	< 0.1%
67	2	< 0.1%
66	1	< 0.1%
64	171	0.1%
63	1344	1.1%
62	163	0.1%
61	241	0.2%

product_description_lenght
Real number (ℝ)

MISSING

Distinct	2960
Distinct (%)	2.6%
Missing	2528
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%
Mean	786.9573

Minimum	4
Maximum	3992
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	4
5-th percentile	160
Q1	347
median	601
Q3	985
95-th percentile	2126
Maximum	3992
Range	3988
Interquartile range (IQR)	638

Descriptive statistics

Standard deviation	653.02901
Coefficient of variation (CV)	0.82981504
Kurtosis	4.9175956
Mean	786.9573
Median Absolute Deviation (MAD)	296
Skewness	2.0100931
Sum	91213073
Variance	426446.89
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
341	710	0.6%
1893	667	0.6%
348	644	0.5%
903	594	0.5%
245	584	0.5%
492	577	0.5%
366	534	0.5%
236	516	0.4%
340	484	0.4%
919	441	0.4%
Other values (2950)	110155	93.0%
(Missing)	2528	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	6	< 0.1%
8	2	< 0.1%
15	1	< 0.1%
20	7	< 0.1%
23	1	< 0.1%
26	2	< 0.1%
27	4	< 0.1%
28	2	< 0.1%
30	8	< 0.1%
31	2	< 0.1%

Value	Count	Frequency (%)
3992	2	< 0.1%
3988	1	< 0.1%
3985	3	< 0.1%
3976	6	< 0.1%
3963	1	< 0.1%
3956	3	< 0.1%
3954	2	< 0.1%
3950	2	< 0.1%
3949	1	< 0.1%
3948	1	< 0.1%

product_photos_qty
Real number (ℝ)

MISSING

Distinct	19
Distinct (%)	< 0.1%
Missing	2528
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.2078495

Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	6
Maximum	20
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.7195193
Coefficient of variation (CV)	0.77882088
Kurtosis	4.8052032
Mean	2.2078495
Median Absolute Deviation (MAD)	0
Skewness	1.9057908
Sum	255903
Variance	2.9567465
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
1	58542	49.4%
2	22896	19.3%
3	12920	10.9%
4	8830	7.5%
5	5585	4.7%
6	3935	3.3%
7	1556	1.3%
8	772	0.7%
10	353	0.3%
9	318	0.3%
Other values (9)	199	0.2%
(Missing)	2528	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	58542	49.4%
2	22896	19.3%
3	12920	10.9%
4	8830	7.5%
5	5585	4.7%
6	3935	3.3%
7	1556	1.3%
8	772	0.7%
9	318	0.3%
10	353	0.3%

Value	Count	Frequency (%)
20	1	< 0.1%
19	2	< 0.1%
18	4	< 0.1%
17	11	< 0.1%
15	12	< 0.1%
14	6	< 0.1%
13	30	< 0.1%
12	60	0.1%
11	73	0.1%
10	353	0.3%

product_weight_g
Real number (ℝ)

HIGH CORRELATION

Distinct	2204
Distinct (%)	1.9%
Missing	850
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	2114.2811

Minimum	0
Maximum	40425
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	0
5-th percentile	125
Q1	300
median	700
Q3	1800
95-th percentile	9850
Maximum	40425
Range	40425
Interquartile range (IQR)	1500

Descriptive statistics

Standard deviation	3788.754
Coefficient of variation (CV)	1.7919822
Kurtosis	16.00722
Mean	2114.2811
Median Absolute Deviation (MAD)	500
Skewness	3.5812411
Sum	2.4860562 × 10⁸
Variance	14354657
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	7051	6.0%
150	5391	4.6%
250	4702	4.0%
300	4419	3.7%
400	3750	3.2%
100	3628	3.1%
350	3264	2.8%
500	2836	2.4%
600	2822	2.4%
700	2131	1.8%
Other values (2194)	77590	65.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8	< 0.1%
2	5	< 0.1%
25	3	< 0.1%
50	988	0.8%
53	2	< 0.1%
54	2	< 0.1%
55	2	< 0.1%
58	1	< 0.1%
60	9	< 0.1%
61	5	< 0.1%

Value	Count	Frequency (%)
40425	3	< 0.1%
30000	302	0.3%
29800	1	< 0.1%
29750	1	< 0.1%
29700	4	< 0.1%
29600	5	< 0.1%
29500	2	< 0.1%
29250	1	< 0.1%
29150	1	< 0.1%
29100	1	< 0.1%

product_length_cm
Real number (ℝ)

HIGH CORRELATION

Distinct	99
Distinct (%)	0.1%
Missing	850
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	30.256872

Minimum	7
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	7
5-th percentile	16
Q1	18
median	25
Q3	38
95-th percentile	62
Maximum	105
Range	98
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	16.190874
Coefficient of variation (CV)	0.53511393
Kurtosis	3.6874379
Mean	30.256872
Median Absolute Deviation (MAD)	8
Skewness	1.7478347
Sum	3557724
Variance	262.14439
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	18274	15.4%
20	10918	9.2%
30	7907	6.7%
17	6177	5.2%
18	5883	5.0%
19	4863	4.1%
25	4833	4.1%
40	4306	3.6%
22	3971	3.4%
50	3149	2.7%
Other values (89)	47303	39.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7	32	< 0.1%
8	2	< 0.1%
9	4	< 0.1%
10	8	< 0.1%
11	96	0.1%
12	41	< 0.1%
13	60	0.1%
14	138	0.1%
15	218	0.2%
16	18274	15.4%

Value	Count	Frequency (%)
105	334	0.3%
104	35	< 0.1%
103	46	< 0.1%
102	59	< 0.1%
101	108	0.1%
100	426	0.4%
99	36	< 0.1%
98	50	< 0.1%
97	11	< 0.1%
96	8	< 0.1%

product_height_cm
Real number (ℝ)

HIGH CORRELATION

Distinct	102
Distinct (%)	0.1%
Missing	850
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	16.63029

Minimum	2
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	8
median	13
Q3	20
95-th percentile	45
Maximum	105
Range	103
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	13.45878
Coefficient of variation (CV)	0.8092932
Kurtosis	7.2720955
Mean	16.63029
Median Absolute Deviation (MAD)	6
Skewness	2.2376777
Sum	1955456
Variance	181.13877
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	10296	8.7%
20	6891	5.8%
15	6839	5.8%
12	6486	5.5%
11	6378	5.4%
2	5213	4.4%
4	4881	4.1%
8	4826	4.1%
16	4742	4.0%
5	4741	4.0%
Other values (92)	56291	47.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	5213	4.4%
3	2809	2.4%
4	4881	4.1%
5	4741	4.0%
6	3553	3.0%
7	4376	3.7%
8	4826	4.1%
9	3371	2.8%
10	10296	8.7%
11	6378	5.4%

Value	Count	Frequency (%)
105	138	0.1%
104	14	< 0.1%
103	49	< 0.1%
102	10	< 0.1%
100	43	< 0.1%
99	5	< 0.1%
98	3	< 0.1%
97	2	< 0.1%
96	8	< 0.1%
95	22	< 0.1%

product_width_cm
Real number (ℝ)

HIGH CORRELATION

Distinct	95
Distinct (%)	0.1%
Missing	850
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	23.068394

Minimum	6
Maximum	118
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	6
5-th percentile	11
Q1	15
median	20
Q3	30
95-th percentile	45
Maximum	118
Range	112
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.748372
Coefficient of variation (CV)	0.50928437
Kurtosis	4.5712383
Mean	23.068394
Median Absolute Deviation (MAD)	6
Skewness	1.7102323
Sum	2712474
Variance	138.02426
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	12650	10.7%
11	11083	9.4%
15	9316	7.9%
16	8775	7.4%
30	7988	6.7%
12	5684	4.8%
13	5456	4.6%
14	4807	4.1%
18	4160	3.5%
40	4130	3.5%
Other values (85)	43535	36.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	2	< 0.1%
7	5	< 0.1%
8	29	< 0.1%
9	51	< 0.1%
10	83	0.1%
11	11083	9.4%
12	5684	4.8%
13	5456	4.6%
14	4807	4.1%
15	9316	7.9%

Value	Count	Frequency (%)
118	8	< 0.1%
105	14	< 0.1%
104	1	< 0.1%
103	1	< 0.1%
102	2	< 0.1%
101	2	< 0.1%
100	43	< 0.1%
98	1	< 0.1%
97	1	< 0.1%
95	2	< 0.1%

product_category
Text

MISSING

Distinct	71
Distinct (%)	0.1%
Missing	2553
Missing (%)	2.2%
Memory size	5.8 MiB

Length

Max length	39
Median length	31
Mean length	12.981162
Min length	3

Characters and Unicode

Total characters	1504270
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	office_furniture
2nd row	housewares
3rd row	office_furniture
4th row	office_furniture
5th row	home_confort

Value	Count	Frequency (%)
bed_bath_table	11823	10.2%
health_beauty	9975	8.6%
sports_leisure	8945	7.7%
furniture_decor	8744	7.5%
computers_accessories	8082	7.0%
housewares	7355	6.3%
watches_gifts	6201	5.4%
telephony	4721	4.1%
garden_tools	4574	3.9%
auto	4379	3.8%
Other values (61)	41082	35.5%

Most occurring characters

Value	Count	Frequency (%)
e	184021	12.2%
s	141292	9.4%
t	132515	8.8%
o	111308	7.4%
r	105097	7.0%
a	101696	6.8%
_	101427	6.7%
u	77730	5.2%
c	72030	4.8%
i	62939	4.2%
Other values (15)	414215	27.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1402544	93.2%
Connector Punctuation	101427	6.7%
Decimal Number	299	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	184021	13.1%
s	141292	10.1%
t	132515	9.4%
o	111308	7.9%
r	105097	7.5%
a	101696	7.3%
u	77730	5.5%
c	72030	5.1%
i	62939	4.5%
h	59263	4.2%
Other values (13)	354653	25.3%

Connector Punctuation

Value	Count	Frequency (%)
_	101427	100.0%

Decimal Number

Value	Count	Frequency (%)
2	299	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1402544	93.2%
Common	101726	6.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	184021	13.1%
s	141292	10.1%
t	132515	9.4%
o	111308	7.9%
r	105097	7.5%
a	101696	7.3%
u	77730	5.5%
c	72030	5.1%
i	62939	4.5%
h	59263	4.2%
Other values (13)	354653	25.3%

Common

Value	Count	Frequency (%)
_	101427	99.7%
2	299	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1504270	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	184021	12.2%
s	141292	9.4%
t	132515	8.8%
o	111308	7.4%
r	105097	7.0%
a	101696	6.8%
_	101427	6.7%
u	77730	5.2%
c	72030	4.8%
i	62939	4.2%
Other values (15)	414215	27.5%

seller_zip_code_prefix
Real number (ℝ)

HIGH CORRELATION

Distinct	2246
Distinct (%)	1.9%
Missing	830
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	24442.886

Minimum	1001
Maximum	99730
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	1001
5-th percentile	2972
Q1	6429
median	13660
Q3	28035
95-th percentile	88316
Maximum	99730
Range	98729
Interquartile range (IQR)	21606

Descriptive statistics

Standard deviation	27573.803
Coefficient of variation (CV)	1.1280911
Kurtosis	0.93603424
Mean	24442.886
Median Absolute Deviation (MAD)	8130
Skewness	1.5556839
Sum	2.8745812 × 10⁹
Variance	7.6031461 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14940	8242	7.0%
5849	2137	1.8%
15025	2089	1.8%
9015	1853	1.6%
13405	1655	1.4%
4782	1547	1.3%
8577	1545	1.3%
3204	1462	1.2%
4160	1267	1.1%
13232	1254	1.1%
Other values (2236)	94553	79.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1001	22	< 0.1%
1021	41	< 0.1%
1022	5	< 0.1%
1023	5	< 0.1%
1026	323	0.3%
1031	129	0.1%
1035	18	< 0.1%
1039	1	< 0.1%
1040	24	< 0.1%
1041	2	< 0.1%

Value	Count	Frequency (%)
99730	12	< 0.1%
99700	2	< 0.1%
99670	1	< 0.1%
99500	61	0.1%
99300	2	< 0.1%
98975	22	< 0.1%
98920	2	< 0.1%
98910	13	< 0.1%
98803	64	0.1%
98780	4	< 0.1%

seller_city
Text

Distinct	611
Distinct (%)	0.5%
Missing	830
Missing (%)	0.7%
Memory size	5.8 MiB

Length

Max length	40
Median length	31
Mean length	10.103466
Min length	2

Characters and Unicode

Total characters	1188208
Distinct characters	41
Distinct categories	9 ?
Distinct scripts	3 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	64 ?
Unique (%)	0.1%

Sample

1st row	itaquaquecetuba
2nd row	itajai
3rd row	itaquaquecetuba
4th row	itaquaquecetuba
5th row	ibitinga

Value	Count	Frequency (%)
sao	36194	17.9%
paulo	29438	14.6%
ibitinga	8242	4.1%
rio	5910	2.9%
do	5505	2.7%
preto	5497	2.7%
de	4181	2.1%
jose	4064	2.0%
santo	3214	1.6%
curitiba	3137	1.6%
Other values (640)	96723	47.9%

Most occurring characters

Value	Count	Frequency (%)
a	197604	16.6%
o	145500	12.2%
i	101338	8.5%
	84561	7.1%
r	77771	6.5%
s	75800	6.4%
e	63824	5.4%
u	62616	5.3%
p	58126	4.9%
l	56675	4.8%
Other values (31)	264393	22.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1102430	92.8%
Space Separator	84561	7.1%
Other Punctuation	612	0.1%
Modifier Symbol	369	< 0.1%
Dash Punctuation	164	< 0.1%
Close Punctuation	31	< 0.1%
Open Punctuation	31	< 0.1%
Decimal Number	8	< 0.1%
Nonspacing Mark	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	197604	17.9%
o	145500	13.2%
i	101338	9.2%
r	77771	7.1%
s	75800	6.9%
e	63824	5.8%
u	62616	5.7%
p	58126	5.3%
l	56675	5.1%
t	46959	4.3%
Other values (14)	216217	19.6%

Other Punctuation

Value	Count	Frequency (%)
'	345	56.4%
/	141	23.0%
.	76	12.4%
@	38	6.2%
\	6	1.0%
,	6	1.0%

Decimal Number

Value	Count	Frequency (%)
4	2	25.0%
2	2	25.0%
5	2	25.0%
0	1	12.5%
8	1	12.5%

Space Separator

Value	Count	Frequency (%)
	84561	100.0%

Modifier Symbol

Value	Count	Frequency (%)
´	369	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	164	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	31	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	31	100.0%

Nonspacing Mark

Value	Count	Frequency (%)
̃	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1102430	92.8%
Common	85776	7.2%
Inherited	2	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	197604	17.9%
o	145500	13.2%
i	101338	9.2%
r	77771	7.1%
s	75800	6.9%
e	63824	5.8%
u	62616	5.7%
p	58126	5.3%
l	56675	5.1%
t	46959	4.3%
Other values (14)	216217	19.6%

Common

Value	Count	Frequency (%)
	84561	98.6%
´	369	0.4%
'	345	0.4%
-	164	0.2%
/	141	0.2%
.	76	0.1%
@	38	< 0.1%
)	31	< 0.1%
(	31	< 0.1%
\	6	< 0.1%
Other values (6)	14	< 0.1%

Inherited

Value	Count	Frequency (%)
̃	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1187837	> 99.9%
None	369	< 0.1%
Diacriticals	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	197604	16.6%
o	145500	12.2%
i	101338	8.5%
	84561	7.1%
r	77771	6.5%
s	75800	6.4%
e	63824	5.4%
u	62616	5.3%
p	58126	4.9%
l	56675	4.8%
Other values (29)	264022	22.2%

None

Value	Count	Frequency (%)
´	369	100.0%

Diacriticals

Value	Count	Frequency (%)
̃	2	100.0%

seller_state
Categorical

HIGH CORRELATION IMBALANCE

Distinct	23
Distinct (%)	< 0.1%
Missing	830
Missing (%)	0.7%
Memory size	5.8 MiB

SP	83854
MG	9260
PR	9017
RJ	5017
SC	4257
Other values (18)	6199

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	235208
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	SP
2nd row	SC
3rd row	SP
4th row	SP
5th row	SP

Common Values

Value	Count	Frequency (%)
SP	83854	70.8%
MG	9260	7.8%
PR	9017	7.6%
RJ	5017	4.2%
SC	4257	3.6%
RS	2283	1.9%
DF	947	0.8%
BA	698	0.6%
GO	549	0.5%
PE	465	0.4%
Other values (13)	1257	1.1%
(Missing)	830	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	83854	71.3%
mg	9260	7.9%
pr	9017	7.7%
rj	5017	4.3%
sc	4257	3.6%
rs	2283	1.9%
df	947	0.8%
ba	698	0.6%
go	549	0.5%
pe	465	0.4%
Other values (13)	1257	1.1%

Most occurring characters

Value	Count	Frequency (%)
P	93400	39.7%
S	90854	38.6%
R	16387	7.0%
M	9879	4.2%
G	9809	4.2%
J	5017	2.1%
C	4361	1.9%
A	1119	0.5%
E	968	0.4%
D	947	0.4%
Other values (6)	2467	1.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	235208	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	93400	39.7%
S	90854	38.6%
R	16387	7.0%
M	9879	4.2%
G	9809	4.2%
J	5017	2.1%
C	4361	1.9%
A	1119	0.5%
E	968	0.4%
D	947	0.4%
Other values (6)	2467	1.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	235208	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	93400	39.7%
S	90854	38.6%
R	16387	7.0%
M	9879	4.2%
G	9809	4.2%
J	5017	2.1%
C	4361	1.9%
A	1119	0.5%
E	968	0.4%
D	947	0.4%
Other values (6)	2467	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	235208	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	93400	39.7%
S	90854	38.6%
R	16387	7.0%
M	9879	4.2%
G	9809	4.2%
J	5017	2.1%
C	4361	1.9%
A	1119	0.5%
E	968	0.4%
D	947	0.4%
Other values (6)	2467	1.0%

order_purchase_year
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 MiB

2018	63924
2017	54105
2016	405

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	473736
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017
2nd row	2018
3rd row	2018
4th row	2018
5th row	2018

Common Values

Value	Count	Frequency (%)
2018	63924	54.0%
2017	54105	45.7%
2016	405	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2018	63924	54.0%
2017	54105	45.7%
2016	405	0.3%

Most occurring characters

Value	Count	Frequency (%)
2	118434	25.0%
0	118434	25.0%
1	118434	25.0%
8	63924	13.5%
7	54105	11.4%
6	405	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	473736	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	118434	25.0%
0	118434	25.0%
1	118434	25.0%
8	63924	13.5%
7	54105	11.4%
6	405	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	473736	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	118434	25.0%
0	118434	25.0%
1	118434	25.0%
8	63924	13.5%
7	54105	11.4%
6	405	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	473736	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	118434	25.0%
0	118434	25.0%
1	118434	25.0%
8	63924	13.5%
7	54105	11.4%
6	405	0.1%

order_purchase_month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0337234

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	8
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.2318054
Coefficient of variation (CV)	0.53562372
Kurtosis	-0.98261973
Mean	6.0337234
Median Absolute Deviation (MAD)	2
Skewness	0.20436226
Sum	714598
Variance	10.444566
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
8	12745	10.8%
5	12684	10.7%
7	12253	10.3%
3	11790	10.0%
6	11209	9.5%
4	11135	9.4%
2	10068	8.5%
1	9614	8.1%
11	9111	7.7%
12	6617	5.6%
Other values (2)	11208	9.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9614	8.1%
2	10068	8.5%
3	11790	10.0%
4	11135	9.4%
5	12684	10.7%
6	11209	9.5%
7	12253	10.3%
8	12745	10.8%
9	5172	4.4%
10	6036	5.1%

Value	Count	Frequency (%)
12	6617	5.6%
11	9111	7.7%
10	6036	5.1%
9	5172	4.4%
8	12745	10.8%
7	12253	10.3%
6	11209	9.5%
5	12684	10.7%
4	11135	9.4%
3	11790	10.0%

order_purchase_day
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.547393

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.6680764
Coefficient of variation (CV)	0.55752602
Kurtosis	-1.1787215
Mean	15.547393
Median Absolute Deviation (MAD)	8
Skewness	0.017350748
Sum	1841340
Variance	75.135549
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	4600	3.9%
16	4286	3.6%
15	4164	3.5%
5	4148	3.5%
6	4120	3.5%
18	4073	3.4%
4	4034	3.4%
19	4030	3.4%
7	4021	3.4%
26	3983	3.4%
Other values (21)	76975	65.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3680	3.1%
2	3844	3.2%
3	3824	3.2%
4	4034	3.4%
5	4148	3.5%
6	4120	3.5%
7	4021	3.4%
8	3982	3.4%
9	3863	3.3%
10	3731	3.2%

Value	Count	Frequency (%)
31	1986	1.7%
30	3021	2.6%
29	3095	2.6%
28	3558	3.0%
27	3810	3.2%
26	3983	3.4%
25	3937	3.3%
24	4600	3.9%
23	3799	3.2%
22	3825	3.2%

order_purchase_hour
Real number (ℝ)

ZEROS

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.75605

Minimum	0
Maximum	23
Zeros	2910
Zeros (%)	2.5%
Negative	0
Negative (%)	0.0%
Memory size	5.8 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	11
median	15
Q3	19
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.3272401
Coefficient of variation (CV)	0.36102075
Kurtosis	0.19316826
Mean	14.75605
Median Absolute Deviation (MAD)	4
Skewness	-0.60239495
Sum	1747618
Variance	28.379487
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
16	8039	6.8%
14	7944	6.7%
11	7821	6.6%
13	7729	6.5%
15	7669	6.5%
10	7392	6.2%
17	7302	6.2%
20	7298	6.2%
21	7290	6.2%
12	7236	6.1%
Other values (14)	42714	36.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2910	2.5%
1	1369	1.2%
2	616	0.5%
3	326	0.3%
4	254	0.2%
5	226	0.2%
6	571	0.5%
7	1428	1.2%
8	3523	3.0%
9	5694	4.8%

Value	Count	Frequency (%)
23	4909	4.1%
22	6947	5.9%
21	7290	6.2%
20	7298	6.2%
19	7043	5.9%
18	6898	5.8%
17	7302	6.2%
16	8039	6.8%
15	7669	6.5%
14	7944	6.7%

Auto

Heatmap
Table

	customer_state	customer_zip_code_prefix	freight_value	order_item_id	order_purchase_day	order_purchase_hour	order_purchase_month	order_purchase_year	order_status	payment_installments	payment_sequential	payment_type	payment_value	price	product_description_lenght	product_height_cm	product_length_cm	product_name_lenght	product_photos_qty	product_weight_g	product_width_cm	seller_state	seller_zip_code_prefix
customer_state	1.000	0.896	0.085	0.013	0.011	0.020	0.021	0.042	0.026	0.032	0.026	0.033	0.029	0.020	0.027	0.019	0.017	0.013	0.014	0.028	0.016	0.054	0.069
customer_zip_code_prefix	0.896	1.000	0.466	-0.009	-0.010	0.012	-0.007	0.036	0.022	0.069	-0.008	0.029	0.106	0.070	0.031	0.019	0.009	0.015	0.026	0.026	-0.002	0.065	0.060
freight_value	0.085	0.466	1.000	-0.055	-0.017	0.007	-0.003	0.028	0.015	0.191	0.018	0.009	0.423	0.434	0.117	0.285	0.284	0.033	0.011	0.449	0.276	0.048	0.257
order_item_id	0.013	-0.009	-0.055	1.000	0.014	-0.015	0.001	0.007	0.002	0.060	-0.007	0.021	0.256	-0.116	-0.031	0.018	0.006	-0.021	-0.064	-0.000	-0.004	0.000	-0.012
order_purchase_day	0.011	-0.010	-0.017	0.014	1.000	-0.013	-0.002	0.083	0.010	-0.001	-0.003	0.007	-0.009	-0.021	-0.004	-0.004	-0.009	0.009	0.000	-0.007	-0.002	0.015	-0.004
order_purchase_hour	0.020	0.012	0.007	-0.015	-0.013	1.000	-0.002	0.018	0.010	0.030	0.013	0.037	-0.006	0.009	-0.009	0.002	0.009	0.001	0.005	0.016	0.011	0.010	-0.004
order_purchase_month	0.021	-0.007	-0.003	0.001	-0.002	-0.002	1.000	0.461	0.024	0.027	0.001	0.030	0.001	0.002	-0.018	0.020	0.002	0.014	0.026	0.009	0.015	0.039	0.009
order_purchase_year	0.042	0.036	0.028	0.007	0.083	0.018	0.461	1.000	0.067	0.048	0.030	0.041	0.008	0.000	0.049	0.041	0.050	0.082	0.029	0.015	0.047	0.084	0.065
order_status	0.026	0.022	0.015	0.002	0.010	0.010	0.024	0.067	1.000	0.005	0.026	0.037	0.015	0.014	0.016	0.015	0.014	0.019	0.013	0.011	0.004	0.029	0.013
payment_installments	0.032	0.069	0.191	0.060	-0.001	0.030	0.027	0.048	0.005	1.000	-0.177	0.236	0.396	0.317	0.033	0.106	0.108	0.016	-0.002	0.198	0.124	0.033	0.066
payment_sequential	0.026	-0.008	0.018	-0.007	-0.003	0.013	0.001	0.030	0.026	-0.177	1.000	0.198	-0.214	-0.006	-0.013	0.013	0.034	-0.003	-0.005	0.030	0.028	0.016	0.007
payment_type	0.033	0.029	0.009	0.021	0.007	0.037	0.030	0.041	0.037	0.236	0.198	1.000	0.018	0.015	0.020	0.015	0.022	0.010	0.004	0.018	0.020	0.021	0.018
payment_value	0.029	0.106	0.423	0.256	-0.009	-0.006	0.001	0.008	0.015	0.396	-0.214	0.018	1.000	0.790	0.169	0.305	0.228	0.024	-0.011	0.449	0.232	0.036	0.160
price	0.020	0.070	0.434	-0.116	-0.021	0.009	0.002	0.000	0.014	0.317	-0.006	0.015	0.790	1.000	0.211	0.328	0.266	0.042	0.029	0.514	0.271	0.052	0.176
product_description_lenght	0.027	0.031	0.117	-0.031	-0.004	-0.009	-0.018	0.049	0.016	0.033	-0.013	0.020	0.169	0.211	1.000	0.134	-0.020	0.073	0.110	0.095	-0.080	0.112	0.002
product_height_cm	0.019	0.019	0.285	0.018	-0.004	0.002	0.020	0.041	0.015	0.106	0.013	0.015	0.305	0.328	0.134	1.000	0.250	-0.057	-0.079	0.533	0.340	0.065	0.050
product_length_cm	0.017	0.009	0.284	0.006	-0.009	0.009	0.002	0.050	0.014	0.108	0.034	0.022	0.228	0.266	-0.020	0.250	1.000	0.060	0.006	0.619	0.632	0.084	0.067
product_name_lenght	0.013	0.015	0.033	-0.021	0.009	0.001	0.014	0.082	0.019	0.016	-0.003	0.010	0.024	0.042	0.073	-0.057	0.060	1.000	0.163	0.075	0.065	0.070	0.009
product_photos_qty	0.014	0.026	0.011	-0.064	0.000	0.005	0.026	0.029	0.013	-0.002	-0.005	0.004	-0.011	0.029	0.110	-0.079	0.006	0.163	1.000	0.004	-0.014	0.040	-0.078
product_weight_g	0.028	0.026	0.449	-0.000	-0.007	0.016	0.009	0.015	0.011	0.198	0.030	0.018	0.449	0.514	0.095	0.533	0.619	0.075	0.004	1.000	0.621	0.078	0.097
product_width_cm	0.016	-0.002	0.276	-0.004	-0.002	0.011	0.015	0.047	0.004	0.124	0.028	0.020	0.232	0.271	-0.080	0.340	0.632	0.065	-0.014	0.621	1.000	0.057	0.078
seller_state	0.054	0.065	0.048	0.000	0.015	0.010	0.039	0.084	0.029	0.033	0.016	0.021	0.036	0.052	0.112	0.065	0.084	0.070	0.040	0.078	0.057	1.000	0.920
seller_zip_code_prefix	0.069	0.060	0.257	-0.012	-0.004	-0.004	0.009	0.065	0.013	0.066	0.007	0.018	0.160	0.176	0.002	0.050	0.067	0.009	-0.078	0.097	0.078	0.920	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	customer_id	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state	order_id	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	payment_sequential	payment_type	payment_installments	payment_value	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	product_category	seller_zip_code_prefix	seller_city	seller_state	order_purchase_year	order_purchase_month	order_purchase_day	order_purchase_hour
0	06b8999e2fba1a1fbc88172c00ba8bc7	861eff4711a542e4b93843c6dd7febb0	14409	franca	SP	00e7ee1b050b8499577073aeb2a297a1	delivered	2017-05-16 15:05:35	2017-05-16 15:22:12	2017-05-23 10:47:57	2017-05-25 10:35:35	2017-06-05 00:00:00	1.0	a9516a079e37a9c9c36b9b78b10169e8	7c67e1448b00f6e969d365cea6b010ab	2017-05-22 15:22:12	124.99	21.88	1.0	credit_card	2.0	146.87	41.0	1141.0	1.0	8683.0	54.0	64.0	31.0	office_furniture	8577.0	itaquaquecetuba	SP	2017	5	16	15
1	18955e83d337fd6b2def6b18a428ac77	290c77bc529b7ac935b93aa66c333dc3	9790	sao bernardo do campo	SP	29150127e6685892b6eab3eec79f59c7	delivered	2018-01-12 20:48:24	2018-01-12 20:58:32	2018-01-15 17:14:59	2018-01-29 12:41:19	2018-02-06 00:00:00	1.0	4aa6014eceb682077f9dc4bffebc05b0	b8bc237ba3788b23da09c0f1f3a3288c	2018-01-18 20:58:32	289.00	46.48	1.0	credit_card	8.0	335.48	43.0	1002.0	3.0	10150.0	89.0	15.0	40.0	housewares	88303.0	itajai	SC	2018	1	12	20
2	4e7b3e00288586ebd08712fdd0374a03	060e732b5b29e8181a18229c7b0b2b5e	1151	sao paulo	SP	b2059ed67ce144a36e2aa97d2c9e9ad2	delivered	2018-05-19 16:07:45	2018-05-20 16:19:10	2018-06-11 14:31:00	2018-06-14 17:58:51	2018-06-13 00:00:00	1.0	bd07b66896d6f1494f5b86251848ced7	7c67e1448b00f6e969d365cea6b010ab	2018-06-05 16:19:10	139.94	17.79	1.0	credit_card	7.0	157.73	55.0	955.0	1.0	8267.0	52.0	52.0	17.0	office_furniture	8577.0	itaquaquecetuba	SP	2018	5	19	16
3	b2b6027bc5c5109e529d4dc6358b12c3	259dac757896d24d7702b9acbbff3f3c	8775	mogi das cruzes	SP	951670f92359f4fe4a63112aa7306eba	delivered	2018-03-13 16:06:38	2018-03-13 17:29:19	2018-03-27 23:22:42	2018-03-28 16:04:25	2018-04-10 00:00:00	1.0	a5647c44af977b148e0a3a4751a09e2e	7c67e1448b00f6e969d365cea6b010ab	2018-03-27 16:31:16	149.94	23.36	1.0	credit_card	1.0	173.30	48.0	1066.0	1.0	12160.0	56.0	51.0	28.0	office_furniture	8577.0	itaquaquecetuba	SP	2018	3	13	16
4	4f2d8ab171c80ec8364f7c12e35b23ad	345ecd01c38d18a9036ed96c73b8d066	13056	campinas	SP	6b7d50bd145f6fc7f33cebabd7e49d0f	delivered	2018-07-29 09:51:30	2018-07-29 10:10:09	2018-07-30 15:16:00	2018-08-09 20:55:48	2018-08-15 00:00:00	1.0	9391a573abe00141c56e38d84d7d5b3b	4a3ca9315b744ce9f8e9374361493884	2018-07-31 10:10:09	230.00	22.25	1.0	credit_card	8.0	252.25	61.0	407.0	1.0	5200.0	45.0	15.0	35.0	home_confort	14940.0	ibitinga	SP	2018	7	29	9
5	879864dab9bc3047522c92c82e1212b8	4c93744516667ad3b8f1fb645a3116a4	89254	jaragua do sul	SC	5741ea1f91b5fbab2bd2dc653a5b5099	delivered	2017-09-14 18:14:31	2017-09-14 18:25:11	2017-09-18 21:27:40	2017-09-28 17:32:43	2017-10-04 00:00:00	1.0	0be701e03657109a8a4d5168122777fb	8f2ce03f928b567e3d56181ae20ae952	2017-09-20 18:25:11	259.90	22.31	1.0	debit_card	1.0	282.21	32.0	282.0	2.0	4450.0	60.0	15.0	15.0	sports_leisure	5141.0	pirituba	SP	2017	9	14	18
6	fd826e7cf63160e536e0908c76c3f441	addec96d2e059c80c30fe6871d30d177	4534	sao paulo	SP	36e694cf4cbc2a4803200c35e84abdc4	delivered	2018-02-19 14:38:35	2018-02-19 14:50:37	2018-02-20 00:03:39	2018-02-20 16:25:51	2018-03-05 00:00:00	1.0	b5466db4cecf95c3c1be0ba32538ce1a	9f505651f4a6abe901a56cdc21508025	2018-02-23 14:50:37	14.99	7.78	1.0	credit_card	1.0	22.77	37.0	322.0	3.0	100.0	16.0	3.0	13.0	computers_accessories	4102.0	sao paulo	SP	2018	2	19	14
7	5e274e7a0c3809e14aba7ad5aae0d407	57b2a98a409812fe9618067b6b8ebe4f	35182	timoteo	MG	1093c8304c7a003280dd34598194913d	delivered	2017-11-16 19:29:02	2017-11-16 19:55:41	2017-11-22 16:46:33	2017-11-27 12:44:36	2017-12-08 00:00:00	1.0	124f74f703e88efe001a10bfa718b6ff	2a7dc43cecabf23403078e2188437d1d	2017-11-22 19:55:41	19.90	16.11	1.0	credit_card	3.0	36.01	NaN	NaN	NaN	250.0	15.0	8.0	20.0	NaN	4142.0	sao paulo	SP	2017	11	16	19
8	5adf08e34b2e993982a47070956c5c65	1175e95fb47ddff9de6b2b06188f7e0d	81560	curitiba	PR	1ebeea841c590e86a14a0d7a48e7d062	delivered	2018-01-18 12:35:44	2018-01-18 12:56:32	2018-01-18 23:25:35	2018-01-26 15:17:57	2018-02-20 00:00:00	1.0	08401f48b67a852d06105725c3013eff	95e03ca3d4146e4011985981aeb959b9	2018-01-30 12:56:32	25.00	14.10	1.0	debit_card	1.0	39.10	58.0	739.0	5.0	350.0	28.0	10.0	12.0	toys	21210.0	rio de janeiro	RJ	2018	1	18	12
9	4b7139f34592b3a31687243a302fa75b	9afe194fb833f79e300e37e580171f22	30575	belo horizonte	MG	7433cbcc783205509d66a5260da5b574	delivered	2018-01-08 11:22:34	2018-01-08 11:35:27	2018-01-11 01:00:40	2018-01-13 14:51:55	2018-02-05 00:00:00	1.0	78efe838c04bbc568be034082200ac20	0241d4d5d36f10f80c644447315af0bd	2018-01-12 11:35:27	99.90	22.57	1.0	credit_card	1.0	122.47	57.0	272.0	1.0	2500.0	40.0	10.0	30.0	furniture_decor	80330.0	curitiba	PR	2018	1	8	11

	customer_id	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state	order_id	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	payment_sequential	payment_type	payment_installments	payment_value	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	product_category	seller_zip_code_prefix	seller_city	seller_state	order_purchase_year	order_purchase_month	order_purchase_day	order_purchase_hour
118424	f255d679c7c86c24ef4861320d5b7675	d111b06b6f3a2add0d2241325f65b5ca	13500	rio claro	SP	ca978d2459ea2c5ef6d5fde02be26b9c	delivered	2018-03-06 09:16:56	2018-03-06 09:29:07	2018-03-06 18:51:58	2018-03-07 20:58:53	2018-03-19 00:00:00	1.0	163da86e86f0089de089399c28c3fcbb	9f505651f4a6abe901a56cdc21508025	2018-03-13 09:29:07	99.00	9.59	1.0	credit_card	3.0	108.59	60.0	407.0	3.0	400.0	16.0	3.0	21.0	computers_accessories	4102.0	sao paulo	SP	2018	3	6	9
118425	14308d2303a3e2bdf4939b86c46d2679	e7f8760e2bbd2f1986bebd99596c088e	66033	belem	PA	ec3a75fb0ac595e461765d2d854b1d08	delivered	2017-03-15 21:04:08	2017-03-15 21:04:08	2017-03-20 08:34:12	2017-04-05 11:07:12	2017-04-26 00:00:00	1.0	6b5af19067eeadc0f331687a79ca656b	bf0045791395e66460eb04749c68672a	2017-03-28 21:04:08	59.90	24.42	2.0	voucher	1.0	40.53	62.0	621.0	1.0	600.0	16.0	6.0	11.0	stationery	4256.0	sao paulo	SP	2017	3	15	21
118426	14308d2303a3e2bdf4939b86c46d2679	e7f8760e2bbd2f1986bebd99596c088e	66033	belem	PA	ec3a75fb0ac595e461765d2d854b1d08	delivered	2017-03-15 21:04:08	2017-03-15 21:04:08	2017-03-20 08:34:12	2017-04-05 11:07:12	2017-04-26 00:00:00	1.0	6b5af19067eeadc0f331687a79ca656b	bf0045791395e66460eb04749c68672a	2017-03-28 21:04:08	59.90	24.42	1.0	voucher	1.0	43.79	62.0	621.0	1.0	600.0	16.0	6.0	11.0	stationery	4256.0	sao paulo	SP	2017	3	15	21
118427	f5a0b560f9e9427792a88bec97710212	b3e53d18a997f27a3ffd16da497eaf58	7790	cajamar	SP	97d6c1727b0d36b8d04035e35d86f40f	delivered	2018-05-18 21:42:33	2018-05-18 21:55:14	2018-06-04 16:03:00	2018-06-05 19:33:24	2018-06-06 00:00:00	1.0	e0d64dcfaa3b6db5c54ca298ae101d05	2eb70248d66e0e3ef83659f71b244378	2018-05-29 21:55:14	124.90	7.74	1.0	credit_card	1.0	132.64	35.0	514.0	2.0	4338.0	17.0	12.0	14.0	watches_gifts	13101.0	campinas	SP	2018	5	18	21
118428	7fe2e80252a9ea476f950ae8f85b0f8f	4b5820135d360a45552b5163835b1d89	35500	divinopolis	MG	c9aea907527f5d4f5fb44955c18a79fb	delivered	2017-12-17 23:13:41	2017-12-18 00:17:27	2017-12-20 18:52:08	2018-01-04 13:08:05	2018-01-23 00:00:00	1.0	c770c3d5ab511e88a96d387bdb0b6ce0	e06f09ec0a4aca210779cf1cfc63cf19	2018-01-03 00:17:27	55.00	20.88	1.0	credit_card	1.0	75.88	12.0	210.0	2.0	1100.0	48.0	24.0	23.0	housewares	4773.0	sao paulo	SP	2017	12	17	23
118429	17ddf5dd5d51696bb3d7c6291687be6f	1a29b476fee25c95fbafc67c5ac95cf8	3937	sao paulo	SP	6760e20addcf0121e9d58f2f1ff14298	delivered	2018-04-07 15:48:17	2018-04-07 16:08:45	2018-04-11 02:08:36	2018-04-13 20:06:37	2018-04-25 00:00:00	1.0	ccb4503d9d43d245d3b295d0544f988b	527801b552d0077ffd170872eb49683b	2018-04-12 16:08:45	74.90	13.88	1.0	credit_card	6.0	88.78	51.0	489.0	2.0	611.0	22.0	22.0	23.0	books_general_interest	17400.0	garca	SP	2018	4	7	15
118430	e7b71a9017aa05c9a7fd292d714858e8	d52a67c98be1cf6a5c84435bd38d095d	6764	taboao da serra	SP	9ec0c8947d973db4f4e8dcf1fbfa8f1b	delivered	2018-04-04 08:20:22	2018-04-04 08:35:12	2018-04-05 18:42:35	2018-04-11 18:54:45	2018-04-20 00:00:00	1.0	9ede6b0570a75a4b9de4f383329f99ee	3fd1e727ba94cfe122d165e176ce7967	2018-04-10 08:35:12	114.90	14.16	1.0	credit_card	3.0	129.06	51.0	1193.0	1.0	1211.0	25.0	24.0	22.0	sports_leisure	14802.0	araraquara	SP	2018	4	4	8
118431	5e28dfe12db7fb50a4b2f691faecea5e	e9f50caf99f032f0bf3c55141f019d99	60115	fortaleza	CE	fed4434add09a6f332ea398efd656a5c	delivered	2018-04-08 20:11:50	2018-04-08 20:30:03	2018-04-09 17:52:17	2018-05-09 19:03:15	2018-05-02 00:00:00	1.0	7a5d2e1e131a860ae7d18f6fffa9d689	d9e7e7778b32987280a6f2cb9a39c57d	2018-04-12 20:30:03	37.00	19.04	1.0	credit_card	5.0	56.04	60.0	575.0	1.0	870.0	25.0	20.0	18.0	health_beauty	3304.0	sao paulo	SP	2018	4	8	20
118432	56b18e2166679b8a959d72dd06da27f9	73c2643a0a458b49f58cea58833b192e	92120	canoas	RS	e31ec91cea1ecf97797787471f98a8c2	delivered	2017-11-03 21:08:33	2017-11-03 21:31:20	2017-11-06 18:24:41	2017-11-16 19:58:39	2017-12-05 00:00:00	1.0	f819f0c84a64f02d3a5606ca95edd272	4869f7a5dfa277a7dca6462dcf3b52b2	2017-11-09 21:15:51	689.00	22.07	1.0	credit_card	2.0	711.07	59.0	452.0	1.0	710.0	19.0	13.0	14.0	watches_gifts	14840.0	guariba	SP	2017	11	3	21
118433	274fa6071e5e17fe303b9748641082c8	84732c5050c01db9b23e19ba39899398	6703	cotia	SP	28db69209a75e59f20ccbb5c36a20b90	delivered	2017-12-19 14:27:23	2017-12-19 18:50:39	2017-12-21 19:17:21	2017-12-26 18:42:36	2018-01-08 00:00:00	1.0	017692475c1c954ff597feda05131d73	3c7c4a49ec3c6550809089c6a2ca9370	2017-12-26 18:50:39	13.99	7.78	1.0	credit_card	1.0	21.77	54.0	933.0	1.0	50.0	16.0	5.0	11.0	perfumery	3804.0	sao paulo	SP	2017	12	19	14

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories